Oracle® Insurance Rules Palette
Two components make up this prototype. First, a transaction was created that references an initial set of rates and then allows a user to enter an adjustment factor that is applied to those rates to create new rate values. The CreateRates business rule was attached to the transaction and is used to insert a new rate group and rate records into the database. The CreateRates rule may be attached to Plan level transactions under a Primary or Subsidiary Company.
A CSR adds the insurance rate activity to a plan or company in OICE. He enters a new effective date (EffectiveDate in AsRateGroup) for the rate and a date when the rates will be available to activities (ActiveToDate in AsRateGroup). An adjustment factor will be applied to the existing rates to create new rate values. The adjustment factor may be a positive or negative decimal value. When the activity is processed, the new rates are created and rates may be expired based on the rate effective date the user has entered. Even when expired, rates are not shadowed as they are still effective for back dating during the time the rate was active.
A set of rates have been initially created for use by the new transaction. The rate description is CreateRates. The initial Effective and Active to Dates are 1/1/2000. There is one criterion, Gender, with two possible values: Male (01), Female (02). There are six rates for each gender.
To view the prototype example in OICE:
Login and select the Prototype Company and Functional Prototype plan.
Create a new policy, add roles, and add at least one segment.
Copyright © 2009, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices